﻿<%@ Page Title="" Language="C#" MasterPageFile="~/common/Admin.master" AutoEventWireup="true" CodeFile="ApplicationPending.aspx.cs" Inherits="product_card_admin_ApplicationPending" %>


<asp:Content ID="Content3" ContentPlaceHolderID="leftMenu" Runat="Server">
<ul>
     <li><a href="<%= Page.ResolveUrl("~/product/saving/admin/saving_apply.aspx")%>">
       Open Saving Account</a></li>
    <li><a href="<%= Page.ResolveUrl("~/product/card/admin/ApplicationPending.aspx")%>">
        Debit Card Applicant List</a></li>
    <li><a href="<%= Page.ResolveUrl("~/product/insurance/admin/insurance_applicant_list.aspx")%>">
        Insurance Applicant List</a></li>
  
                   
    </ul>
    <p>
        <br />
        <br />
        <br />
    </p>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="content" Runat="Server">
    <p>
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <asp:GridView ID="gvPlayers" runat="server" AutoGenerateColumns="False" 
            BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" 
            CellPadding="2" DataKeyNames="id" DataSourceID="SqlDataSource1" 
            ForeColor="Black" GridLines="None" 
       

            AllowSorting="True">
            <AlternatingRowStyle BackColor="PaleGoldenrod" />
            <Columns>
            
          
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                    ReadOnly="True" SortExpression="id" />
                    
                <asp:BoundField DataField="custID" HeaderText="custID" 
                    SortExpression="custID" />
                <asp:BoundField DataField="frontname" HeaderText="frontname" 
                    SortExpression="frontname" />
                <asp:BoundField DataField="firstname" HeaderText="firstname" 
                    SortExpression="firstname" />
                <asp:BoundField DataField="lastname" HeaderText="lastname" 
                    SortExpression="lastname" />
                <asp:BoundField DataField="home" HeaderText="home" 
                    SortExpression="home" />
                <asp:BoundField DataField="office" HeaderText="office" 
                    SortExpression="office" />
                <asp:BoundField DataField="mobile" HeaderText="mobile" 
                    SortExpression="mobile" />
                <asp:BoundField DataField="email" HeaderText="email" 
                    SortExpression="email" />
                <asp:BoundField DataField="nation" HeaderText="nation" 
                    SortExpression="nation" />
                <asp:BoundField DataField="NRIC" HeaderText="NRIC" 
                    SortExpression="NRIC" />
                <asp:BoundField DataField="country" HeaderText="country" 
                    SortExpression="country" />
                <asp:BoundField DataField="dob" HeaderText="dob" 
                    SortExpression="dob" />
                <asp:BoundField DataField="gender" HeaderText="gender" 
                    SortExpression="gender" />
                <asp:BoundField DataField="postalCode" HeaderText="postalCode" 
                    SortExpression="postalCode" />
                <asp:BoundField DataField="jobTittle" HeaderText="jobTittle" 
                    SortExpression="jobTittle" />
                <asp:BoundField DataField="employer" HeaderText="employer" 
                    SortExpression="employer" />
                <asp:BoundField DataField="accountNo" HeaderText="accountNo" 
                    SortExpression="accountNo" />
                <asp:BoundField DataField="applicationDate" HeaderText="applicationDate" 
                    SortExpression="applicationDate" />
                <asp:BoundField DataField="status" HeaderText="status" 
                    SortExpression="status" />
            </Columns>
            <FooterStyle BackColor="Tan" />
            <HeaderStyle BackColor="Tan" Font-Bold="True" />
            <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" 
                HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
            <SortedAscendingCellStyle BackColor="#FAFAE7" />
            <SortedAscendingHeaderStyle BackColor="#DAC09E" />
            <SortedDescendingCellStyle BackColor="#E1DB9C" />
            <SortedDescendingHeaderStyle BackColor="#C2A47B" />
        </asp:GridView>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
     
             SelectCommand="SELECT * FROM [APPLICATIONDEBIT]"
  DeleteCommand = "DELETE FROM [ApplicationDebit] WHERE [id] = @id"
            UpdateCommand = "UPDATE [ApplicationDebit] SET 
            [frontName] = @frontName , [firstname] = @firstname , [lastname] = @lastname, [home] = @home, [office] = @office, [mobile] = @mobile , [email] = @email, [nation] = @nation, [NRIC] = @NRIC, [country] = @country, [dob] = @dob, [gender] = @gender, [postalCode] = @postalCode, [jobTittle] = @jobTittle , [employer] = @employer, [accountNo] = @accountNo, [applicationDate] = @applicationDate, [status] = @status
            WHERE [custID] = @custID">
            <UpdateParameters>
            <asp:Parameter Name = "frontName" Type = String />
           <asp:Parameter Name = "firstname" Type = String />
          <asp:Parameter Name = "lastname" Type = String />
              <asp:Parameter Name = "home" Type = String />
                <asp:Parameter Name = "office" Type = String />
               <asp:Parameter Name = "mobile" Type = String />
               <asp:Parameter Name = "email" Type = String />
              <asp:Parameter Name = "nation" Type = String />
             <asp:Parameter Name = "country" Type = String />
            <asp:Parameter Name = "dob" Type = String />
             <asp:Parameter Name = "gender" Type = String />
            <asp:Parameter Name = "postalCode" Type = String />
           <asp:Parameter Name = "jobTittle" Type = String />
            <asp:Parameter Name = "employer" Type = String />
            <asp:Parameter Name = "accountNo" Type = String />
             <asp:Parameter Name = "applicationDate" Type = String />
     <asp:Parameter Name = "status" Type = String />
            <asp:Parameter Name = "custID" />
   
        </UpdateParameters>
                  </asp:SqlDataSource>
           
       
&nbsp;&nbsp;&nbsp;
        <br />
        <asp:DropDownList ID="DropDownList1" runat="server" 
            DataSourceID="SqlDataSource1" DataTextField="custID" DataValueField="id" >
        </asp:DropDownList>
        <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <br />
        <br />
        <br />
        &nbsp;
        <asp:TextBox ID="TextBox8" runat="server" style="margin-bottom: 0px" 
            Visible="False">powersaverbanknyp@gmail.com</asp:TextBox>
        <br />
        <br />
        &nbsp;<asp:TextBox ID="TextBox9" runat="server" Visible="False">s9518299b</asp:TextBox>
        <br />
        <br />
        <asp:Label ID="Label1" runat="server" Text=" To :"></asp:Label>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="TextBox1" runat="server" ></asp:TextBox>
        <br />
        <br />
        <asp:Label ID="Label3" runat="server" Text="Subject :"></asp:Label>
&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
        <br />
        <br />
        <asp:Label ID="Label4" runat="server" Text="Message :"></asp:Label>
&nbsp;
        <br />
        <asp:TextBox ID="TextBox4" runat="server" Height="181px" TextMode="MultiLine" 
            Width="236px"></asp:TextBox>
             <br />
        <br />
             <asp:FileUpload ID="fileUpload1" runat="server" />
        <br />
        <br />
        <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="Send" />
        &nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Button ID="Button4" runat="server" onclick="Button4_Click" Text="Accept" />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <asp:Label ID="Label5" runat="server" Visible="False">APPROVED</asp:Label>
        <br />
        <br />
        <asp:TextBox ID="TextBox6" runat="server" Visible="False"></asp:TextBox>
        <br />
        <asp:TextBox ID="TextBox7" runat="server" TextMode="MultiLine" Visible="False"></asp:TextBox>
        <asp:TextBox ID="TextBox10" runat="server" Visible="False">0</asp:TextBox>
        <br />
    </p>
</asp:Content>

